Release 10.1A: OpenEdge Data Management:
SQL Reference

CEILING

Returns the smallest integer greater than or equal to expression.

Syntax

CEILING ( expression )

Example

This example illustrates the CEILING function:

SELECT CEILING (32.5) 'Ceiling' FROM SYSPROGRESS.SYSCALCTABLE;

Note

The expression must evaluate to a numeric data type.

Compatibility

ODBC compatible